package com.originskyseed.platform.user.mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.originskyseed.platform.user.model.Player;
import com.originskyseed.platform.user.model.RankingListVO;
import com.originskyseed.platform.user.model.TaskSelectPlayerVO;

/**
 * 玩家信息表Mapper类（OSI_PLAYER）
 *
 * @author wlj
 */
public interface PlayerMapper {

	/**
	 * 删除记录
	 *
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public int deleteByPrimaryKey(String id) throws Exception;

	/**
	 * 批量删除记录
	 *
	 * @param ids
	 * @return
	 * @throws Exception
	 */
	public int deleteByPrimaryKeys(List<String> ids) throws Exception;

	/**
	 * 插入记录
	 *
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int insert(Player record) throws Exception;

	/**
	 * 插入记录（仅非空值字段）
	 *
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int insertSelective(Player record) throws Exception;

	/**
	 * 更新记录
	 *
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int updateByPrimaryKey(Player record) throws Exception;

	/**
	 * 更新记录（仅非空值字段）
	 *
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public int updateByPrimaryKeySelective(Player record) throws Exception;



	/**
	 * 更新记录（仅非空值字段）
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public int updateByPlayerIdAndChannelTime(Map<String, Object> params) throws Exception;

	/**
	 * 玩家是否在线
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public int updatePlayerIsOnLineByList(@Param("list") List<String> list) throws Exception;

	/**
	 * 查询记录
	 *
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public Player selectByPrimaryKey(String id) throws Exception;

	/**
	 * 查询记录,根据玩家id
	 *
	 * @param playerId
	 * @return
	 * @throws Exception
	 */
	public Player selectByPlayerId(String playerId) throws Exception;

	/**
	 * 查询列表
	 *
	 * @param record
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectList(Player record) throws Exception;

	/**
	 * 分页查询列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectListByPage(Map<String, Object> params) throws Exception;

	/**
	 * 查询金额,根据子渠道id
	 *
	 * @param
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectAmountByChannelSubId(@Param("channelSubId") String channelSubId) throws Exception ;

	/**
	 * 查询玩家
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<TaskSelectPlayerVO> taskSelectPlayerToSalerListByPage(Map<String, Object> params) throws Exception;

	/**
	 * 查询玩家
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<TaskSelectPlayerVO> taskSelectPlayerToAnchorListByPage(Map<String, Object> params) throws Exception;

	/**
	 * 玩家注册信息_分页查询列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectLoginListByPage(Map<String, Object> params) throws Exception;

	/**
	 * 推广平台_业务员_玩家信息分页查询
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectPlayerListByPage(Map<String, Object> params) throws Exception;

	/**
	 * 查询业务员直播装换率
	 *
	 * @param anchorId
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectLiveRateByAnchorId(String anchorId) throws Exception;

	/**
	 * 内容平台_主播_玩家信息分页查询
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectPlayerListToAnchorByPage(Map<String, Object> params) throws Exception;

	/**
	 * 内容平台_OW_玩家信息分页查询
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectPlayerListToOWByPage(Map<String, Object> params) throws Exception;

	/**
	 * 业务员_私域用户流量池列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectPlayerPlowPoolListByPage(Map<String, Object> params) throws Exception;

	/**
	 * 业务员_公域域用户流量池列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectPlayerPublicPlowPoolListByPage(Map<String, Object> params) throws Exception;

	/**
	 * 主播_公域用户流量池列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectPlayerPlowPoolListToAnchorByPage(Map<String, Object> params) throws Exception;

	/**
	 * 根据业务员Id查询工会Id
	 *
	 * @param id
	 * @return
	 * @throws Exception
	 */
	public Player selectTradeBybelongBusinessId(String id) throws Exception;

	/**
	 * 根据业务员Id查询工会Id
	 *
	 * @param playerId
	 * @return
	 * @throws Exception
	 */
	public Player selectPlayerByPlayerId(String playerId) throws Exception;

	/**
	 * 查询玩家id是否存在
	 *
	 * @param playerIds
	 * @return
	 * @throws Exception
	 */
	public List<String> selectPlayerIds(List<String> playerIds) throws Exception;

	/**
	 * 根据player查询玩家信息
	 *
	 * @param player
	 * @return
	 * @throws Exception
	 */
	public Player selectPlayerByPlayer(Player player) throws Exception;

	/**
	 * 批量插入记录
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public int insertBatch(List<Player> list) throws Exception;

	/**
	 * 分页查询用户明细信息列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectUserDetailsByPage(Map<String, Object> params) throws Exception;

	/**
	 * 分页查询用户明细信息列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectUserByPage(Map<String, Object> params) throws Exception;

	/**
	 * 分页查询优质用户列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectHighQualityUserByPage(Map<String, Object> params) throws Exception;

	/**
	 * 分页查询活跃登录用户列表
	 *
	 * @param params
	 * @return
	 * @throws Exception
	 */
	public List<Player> selectActiveLoginUserByPage(Map<String, Object> params) throws Exception;

	/**
	 * 查询设备数量
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Integer selectEquipmentNum(List<String> list) throws Exception;

	/**
	 * 查询新用户充值金额
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectNewUserRechargeAmount(List<String> list) throws Exception;

	/**
	 * 查询新用户充值金额
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectContentNewUserRechargeAmount(List<String> list) throws Exception;

	/**
	 * 查询优质用户数量
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Integer selectHighQualityUserNum(List<String> list) throws Exception;

	/**
	 * 查询内容优质用户数量
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Integer selectContentHighQualityUserNum(List<String> list) throws Exception;

	/**
	 * 查询充值用户数量
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Integer selectRechargeUserNum(List<String> list) throws Exception;

	/**
	 * 查询充值用户数量
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Integer selectContentRechargeUserNum(List<String> list) throws Exception;

	/**
	 * 查询累计充值额度
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectRechargeUserAmount(List<String> list) throws Exception;

	/**
	 * 查询内容累计充值额度
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectContentRechargeUserAmount(List<String> list) throws Exception;

	/**
	 * 查询成本
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectBasePay(List<String> list) throws Exception;

	/**
	 * 查询成本
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectAnchorBasePay(List<String> list) throws Exception;

	/**
	 * 查询毛利
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectGrossProfit(Map<String, Object> map) throws Exception;

	/**
	 * 查询业务员用户ltv
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectSalesmanUserLtv(Map<String, Object> map) throws Exception;

	/**
	 * 查询主播用户ltv
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectAnchorUserLtv(Map<String, Object> map) throws Exception;


	/**
	 * 查询业务员用户ltv，查询月表
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectSalesmanUserLtvByMonth(Map<String, Object> map) throws Exception;

	/**
	 * 查询主播用户ltv，查询月表
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectAnchorUserLtvByMonth(Map<String, Object> map) throws Exception;

	/**
	 * 查询毛利
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectAnchorGrossProfit(Map<String, Object> map) throws Exception;

	/**
	 * 查询优质用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectHighQualityUsers(Map<String, Object> map) throws Exception;

	/**
	 * 查询主播心动用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectHeartbeatCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询pk主播心动用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer pkSelectHeartbeatCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询内容优质用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectContentHighQualityUsers(Map<String, Object> map) throws Exception;

	/**
	 * 查询潜力用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectPotentialUsers(Map<String, Object> map) throws Exception;

	/**
	 * 查询内容潜力用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectContentPotentialUsers(Map<String, Object> map) throws Exception;

	/**
	 * 查询新充金额
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectNewChargeAmount(Map<String, Object> map) throws Exception;

	/**
	 * 查询内容新充金额
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectContentNewChargeAmount(Map<String, Object> map) throws Exception;

	/**
	 * pk查询新充总额
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal pkSelectNewChargeAmountSum(Map<String, Object> map) throws Exception;

	/**
	 * 查询新充总额
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectNewChargeAmountSum(Map<String, Object> map) throws Exception;

	/**
	 * 查询内容新充总额
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectContentNewChargeAmountSum(Map<String, Object> map) throws Exception;

	/**
	 * 查询新充总额
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectNewChargeAmountMax(Map<String, Object> map) throws Exception;

	/**
	 * 查询内容新充总额
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectContentNewChargeAmountMax(Map<String, Object> map) throws Exception;

	/**
	 * 查询任务发布数量
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Integer selectTaskReleaseNums(List<String> list) throws Exception;

	/**
	 * 查询新增任务
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectNewTasks(Map<String, Object> map) throws Exception;

	/**
	 * 查询完成任务
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectFinishTheTask(Map<String, Object> map) throws Exception;

	/**
	 * 查询未完成任务
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectIncompleteTask(Map<String, Object> map) throws Exception;

	/**
	 * 查询新增的任务发布数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectNewTasksNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询业务员数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectSalesmenNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询主播数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectAnchorNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询新增业务员数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectAddSalesmenNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询新增业务员总数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectAddSalesmenNumberCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询新增设备数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectAddEquipmentNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询新增设备数量总数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectAddEquipmentNumberCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询新用户充值数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectNewUserRecharge(Map<String, Object> map) throws Exception;

	/**
	 * 查询新用户充值数量总数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectNewUserRechargeCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询优质用户数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectHighQualityUser(Map<String, Object> map) throws Exception;

	/**
	 * 查询优质用户数量总数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectHighQualityUserCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询潜力用户数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer pkSelectPotentialUsersCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询充值用户数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectRechargeUser(Map<String, Object> map) throws Exception;

	/**
	 * 查询充值用户数量总数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectRechargeUserCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询累计充值额度
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectTiredAndFull(Map<String, Object> map) throws Exception;

	/**
	 * 查询累计充值额度总数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectTiredAndFullCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询内容累计充值额度总数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectContentTiredAndFullCount(Map<String, Object> map) throws Exception;

	/**
	 * 查询工会任务汇总
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectTaskSummary(List<String> list) throws Exception;

	/**
	 * 查询业务员逾期情况
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectSalesmanOverdue(Map<String, Object> map) throws Exception;

	/**
	 * 查询累计充值额度,根据时间查询
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectRechargeUserAmountByDate(Map<String, Object> map) throws Exception;

	/**
	 * 查询潜力用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectPotentialUsersByPage(Map<String, Object> map) throws Exception;

	/**
	 * 查询优质用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectHighQualityUsersByPage(Map<String, Object> map) throws Exception;

	/**
	 * 查询私域流量池用户
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectFlowPoolUsersByPage(Map<String, Object> map) throws Exception;

	/**
	 * 查询工会用户
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectUnionUsers(List<String> list) throws Exception;

	/**
	 * 查询业务员排行榜
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectSalesmanRanking(Map<String, Object> map) throws Exception;

	/**
	 * 查询新增注册用户统计
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectNewRegisteredUsers(Map<String, Object> map) throws Exception;

	/**
	 * 查询我的任务
	 *
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectMyMission(@Param("userId") String userId) throws Exception;

	/**
	 * 查询任务统计
	 *
	 * @param list
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectMyMissionByUserIds(List<String> list) throws Exception;

	/**
	 * 查询业务员下的当天新增注册玩家和有效玩家玩家
	 *
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectSalesmanPlayerNumber(@Param("userId") String userId) throws Exception;

	/**
	 * 查询优质用户数
	 *
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public Integer selectHighQualityUsersNumber(@Param("userId") String userId) throws Exception;

	/**
	 * 查询当天注册数
	 *
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public Integer selectTodayRegisterNumber(@Param("userId") String userId) throws Exception;

	/**
	 * 查询任务数量
	 *
	 * @param userId
	 * @return
	 * @throws Exception
	 */
	public Map<String, Object> selectTaskNumber(@Param("userId") String userId) throws Exception;

	/**
	 * 查询大于0的榜单
	 *
	 * @return
	 * @throws Exception
	 */
	public List<RankingListVO> selectSalesmanRankingList(List<String> list) throws Exception;

	/**
	 * 查询维护任务和推广任务的对象
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<String> selectPromotionTaskMaintenanceTask(Map<String, Object> map) throws Exception;

	/**
	 * 查询充值玩家的数量
	 *
	 * @param anchorId
	 * @return
	 * @throws Exception
	 */
	public Integer selectRechargePlayerNumber(@Param("anchorId") String anchorId) throws Exception;

	/**
	 * 查询访问玩家的数量
	 *
	 * @param anchorId
	 * @return
	 * @throws Exception
	 */
	public Integer selectVisitPlayerNumber(@Param("anchorId") String anchorId) throws Exception;

	/**
	 * 查询访问玩家的数量
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer pkSelectAnchorVisitsNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询主播的收益
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public BigDecimal selectAnchorProfit(Map<String, Object> map) throws Exception;

	/**
	 * 查询优质主播排行
	 *
	 * @return
	 * @throws Exception
	 */
	public List<RankingListVO> selectQualityAnchorRanking(Map<String, Object> map) throws Exception;

	/**
	 * 查询工会排行
	 *
	 * @return
	 * @throws Exception
	 */
	public List<RankingListVO> selectLabourUnionRanking(List<String> list) throws Exception;

	/**
	 * 房间曝光量
	 *
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectVisitsNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询新增用户数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectNewUsersVisitsNumber(Map<String, Object> map) throws Exception;

	/**
	 * 查询公会用户消费TOP榜
	 *
	 * @return
	 * @throws Exception
	 */
	public List<RankingListVO> selectConsumptionRanking(Map<String, Object> map) throws Exception;

	/**
	 * 查询访问用户数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectVisitsNumberByTime(Map<String, Object> map) throws Exception;

	/**
	 * 查询充值用户数
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public Integer selectConsumeUserNum(Map<String, Object> map) throws Exception;

	/**
	 * 分页查询主播转换率
	 *
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectAnchorConversionRateByPage(Map<String, Object> params) throws Exception;

	/**
	 * 查询首次进房排行榜
	 *
	 * @return
	 * @throws Exception
	 */
	public List<RankingListVO> selectFirstGetintoHousingRanking(Map<String, Object> map) throws Exception;

	/**
	 * 查询转换率排行榜
	 *
	 * @return
	 * @throws Exception
	 */
	public List<RankingListVO> selectConversionRateRanking(Map<String, Object> map) throws Exception;

	/**
	 * 查询主播排麦直播时长排行、主播个人直播时长排行
	 *
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectAnchorLiveTime(Map<String, Object> params) throws Exception;

	/**
	 * 查询自带粉排行
	 *
	 * @return
	 * @throws Exception
	 */
	public List<Map<String, Object>> selectAnchorByoFans(Map<String, Object> params) throws Exception;

	/**
	 * 统计业务员推广主播数
	 *
	 * @return
	 * @throws Exception
	 */
	public Integer countTaskAnchorNum(Map<String, Object> params) throws Exception;



	/**
	 * 分页查询优质用户列表
	 *
	 * @return
	 * @throws Exception
	 */
	public List<Player> statisticsHighQualityUser(@Param("size") Integer size) throws Exception;


	/**
	 * 查询玩家数量，根据主播id和时间查询
	 * @return
	 * @throws Exception
	 */
	public Integer selectPlayerNumByAnchorId(Map<String, Object> params) throws Exception;


	/**
	 * 查询优质玩家数量，根据主播id和时间查询
	 * @return
	 * @throws Exception
	 */
	public Integer selectHighQualityUserNumByAnchorId(Map<String, Object> params) throws Exception;


	/**
	 * 根据时间查询月度新注册玩家id
	 *
	 * @param map
	 * @return
	 * @throws Exception
	 */
	public List<String> selectNewPlayerIdsByChannelSubId(Map<String,Object> map) throws Exception;
}
